<?php
/**
 * manage newsletter
 */
class NewsletterController extends Controller {

    /**
     * Displays a particular model.
     * @param integer $id the ID of the model to be displayed
     */
    public function actionView($id) {
        $this->render('view', array(
            'model' => $this->loadModel($id),
        ));
    }

    /**
     * Creates a new model.
     * If creation is successful, the browser will be redirected to the 'view' page.
     */
    public function actionCreate() {
        $model = new Subscriber;

        // Uncomment the following line if AJAX validation is needed
        // $this->performAjaxValidation($model);

        if (isset($_POST['Subscriber'])) {
            $model->attributes = $_POST['Subscriber'];
            if ($model->save())
                $this->redirect(array('view', 'id' => $model->id));
        }

        $this->render('create', array(
            'model' => $model,
        ));
    }

    /**
     * Updates a particular model.
     * If update is successful, the browser will be redirected to the 'view' page.
     * @param integer $id the ID of the model to be updated
     */
    public function actionUpdate($id) {
        $model = $this->loadModel($id);

        // Uncomment the following line if AJAX validation is needed
        // $this->performAjaxValidation($model);

        if (isset($_POST['Subscriber'])) {
            $model->attributes = $_POST['Subscriber'];
            if ($model->save())
                $this->redirect(array('view', 'id' => $model->id));
        }

        $this->render('update', array(
            'model' => $model,
        ));
    }

    /**
     * Deletes a particular model.
     * If deletion is successful, the browser will be redirected to the 'admin' page.
     * @param integer $id the ID of the model to be deleted
     */
    public function actionDelete($id) {
        if (Yii::app()->request->isPostRequest) {
            // we only allow deletion via POST request
            $this->loadModel($id)->delete();

            // if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
            if (!isset($_GET['ajax']))
                $this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('admin'));
        }
        else
            throw new CHttpException(400, 'Invalid request. Please do not repeat this request again.');
    }

    /**
     * Manages all models.
     */
    public function actionIndex() {
        $model = new Subscriber('search');
        $model->unsetAttributes();  // clear any default values
        if (isset($_GET['Subscriber']))
            $model->attributes = $_GET['Subscriber'];

        $this->render('index', array(
            'model' => $model,
        ));
    }

    /**
     * Returns the data model based on the primary key given in the GET variable.
     * If the data model is not found, an HTTP exception will be raised.
     * @param integer the ID of the model to be loaded
     */
    public function loadModel($id) {
        $model = Subscriber::model()->findByPk($id);
        if ($model === null)
            throw new CHttpException(404, 'The requested page does not exist.');
        return $model;
    }

    /**
     * Performs the AJAX validation.
     * @param CModel the model to be validated
     */
    protected function performAjaxValidation($model) {
        if (isset($_POST['ajax']) && $_POST['ajax'] === 'subscriber-form') {
            echo CActiveForm::validate($model);
            Yii::app()->end();
        }
    }

    /**
     * send newsletter to subscriber or all members...
     */
    public function actionSend(){
        $model = new SendNewsletterForm();

        if(isset($_GET['email'])){
            $model->email = $_GET['email'];
        }

        if(r()->isPostRequest){
            $model->attributes = $_POST['SendNewsletterFormd'];

            //validate model and send email
            if($model->validate()){
                if($model->group == 'subscriber'){
                    //get all subscriber
                    $subscribers = db()->createCommand()
                            ->select('email')
                            ->from('{{subscribers}}')
                            ->queryAll();
                }else{
                    //find all members
                    //get all subscriber
                    $subscribers = db()->createCommand()
                            ->select('email')
                            ->from('{{users}}')
                            ->queryAll();
                }

                foreach($subscribers as $subscriber){
                    //send email to client
                    EmailHelper::send($subscriber['email'], $model->subject, $model->body);
                }

                user()->setFlash('success', 'Emails has been sent');

                $this->refresh();
            }
        }

        $this->render('send', array(
            'model' => $model
        ));
    }

}
